CREATE TABLE [BBCarrera]
(
	[id] INT  NOT NULL IDENTITY,
	[descripcion] VARCHAR(150)  NULL,
);
CREATE TABLE [BBFacultad]
(
	[id] INT  NOT NULL IDENTITY,
	[descripcion] VARCHAR(150)  NULL,
);
CREATE TABLE [BBUnidadAcademica]
(
	[id] INT  NOT NULL IDENTITY,
	[descripcion] VARCHAR(150)  NULL,
);

ALTER TABLE dbo.BBPersona
ADD  [telefono] VARCHAR(60)  NULL
GO
ALTER TABLE dbo.BBPersona
ADD  [unidad_academica_id] int  NULL 
GO
ALTER TABLE dbo.BBPersona
ADD  [carrea_id] int  NULL 
GO
ALTER TABLE dbo.BBPersona
ADD  [facultad_id] int  NULL 

GO

--
--BEGIN
--ALTER TABLE [BBPersona] ADD CONSTRAINT [BBPersona_FK_2] FOREIGN KEY ([facultad_id]) REFERENCES [BBFacultad] ([id]) ON DELETE CASCADE
--END
--BEGIN
--ALTER TABLE [BBPersona] ADD CONSTRAINT [BBPersona_FK_2] FOREIGN KEY ([carrera_id]) REFERENCES [BBCarrera] ([id]) ON DELETE CASCADE
--END
--BEGIN
--ALTER TABLE [BBPersona] ADD CONSTRAINT [BBPersona_FK_3] FOREIGN KEY ([unidad_academica_id]) REFERENCES [BBUnidadAcademica] ([id]) ON DELETE CASCADE
--END